BEGIN TRANSACTION

ALTER TABLE Sites DROP COLUMN [Description]
ALTER TABLE Sites DROP COLUMN DefaultPage
ALTER TABLE Sites DROP COLUMN Skin
ALTER TABLE Sites DROP COLUMN RegistrationType
ALTER TABLE Sites DROP COLUMN Culture
GO

ALTER TABLE Sites ADD Fields XML NULL

GO

UPDATE Sites
Set Fields='<FieldsDictionary><Description type="System.String, mscorlib"><string>Default site</string></Description><DefaultPage type="System.Guid, mscorlib"><guid>702819f2-2959-4a81-9b71-2b3101a1cbee</guid></DefaultPage><Skin type="System.String, mscorlib"><string>iTheme</string></Skin><RegistrationType type="System.Int32, mscorlib"><int>1</int></RegistrationType><Culture type="System.String, mscorlib"><string>uk-UA</string></Culture></FieldsDictionary>'
WHERE Id = 1

UPDATE Sites
Set Fields='<FieldsDictionary><Description type="System.String, mscorlib"><string>Sub site</string></Description><DefaultPage type="System.Guid, mscorlib"><guid>702819f2-2959-4a81-9b71-2b3101a1cbee</guid></DefaultPage><Skin type="System.String, mscorlib"><string>iTheme</string></Skin><RegistrationType type="System.Int32, mscorlib"><int>1</int></RegistrationType><Culture type="System.String, mscorlib"><string>uk-UA</string></Culture></FieldsDictionary>'
WHERE Id = 2 
GO

COMMIT